CREATE OR REPLACE PACKAGE "kesplus_app"."kes_plus_pkg_build" AUTHID CURRENT_USER AS
    function add(jsonData text) return boolean;
    function del(ids varchar) return boolean;
    procedure update(jsonData text);
    function get_by_id(id varchar) return json;
    function list(jsonData text) return json;
    function page(jsonData text) return json;
    function getFunctions() return json;
    function getProcedures() return json;
    function getViews() return json;
    function getPackages() return json;
    TB_NAME VARCHAR := 'kes_app_build';
    PK_COLUMN_NAME VARCHAR := 'id';
    CONDITIONS json := '[{"blurry":"app_id","queryType":"=","keyName":"appId"}]'::json;
end;

CREATE OR REPLACE PACKAGE BODY "kesplus_app"."kes_plus_pkg_build" AS WRAPPED
JRg2h7P8/vjdlgRpsm7+XhtMoHzF45IPBI3jvdgmEdNNDF+Cf6x0EoTU/s9o
B1o3byywPJxg388uXmkHzicthfYxQjaE1DihkafnqXT0pMP2jle80AZ/l525
oF0pRwuAHDuJtApvFZTu8lUagX9rTnzb7AqQYOwEGleA/eZI9CwlqoGkEBo1
JyGJlR6MImWf0IG0w9gfFQBq0aS/1uCDV1mUVeqgUpvsjztjGm/gsBXPzbdF
L+VgHrOwp5hSoAzKWcDf0isg4kkAfqUpvx9b+oOlDxdeSmgzGFRndnEIS4Xf
FQNEUgHIjHxnR6BCO0E1ubsMNYg+pHoXY+872nNcvhAiZGEXF/tp4QfQj/EM
TJi1Y06CCRB1idbRoSUGv5fzgwuruSnEbxK9N+o7n1QogjjqPT91fcMlf3ao
nf2Pla526YzDiqX2ZKk94WRsYY5TSQf5QzZUpdd8iPrGWfuByLebh4f37pXX
wHPIoVCCvPD1Wqzsg8i2BdTzRfs7Mc9gr6//WFk+XqsiA1PqzQLjeuDdl+k+
KotyXy6otEvCPSfFsbNwP6Rjy7aCvGzyCxNnd6d3jrHEg0JhipnnItAbXIQm
kPlaM4xfdWkXJXIPjkrLpa9DQz/4NSULUz1w2jEgtkjg7e0j58ImBHSg7bKJ
5rllvrdnBJEEBfAjX4ErKglpHd3wM2O18wvdoZFpRsrXHrOUOcMUQK++WKJs
51fmpRGE2JdhexrKAjkvnB8KPnzpWbw5Gl6bz+xDcNYZpH6cHaaaNTOoZSAG
kdK5RwKi8P08VOZqNP3AdLUVVdNQdnEVvJEqZjZJl+M9RL7GkOBU0bv2vCMG
q3oiJkye2gpUMxGSUThHUz3cRre2xDFF+Rfg4hSxKpRw7LWehDcYpojyY88s
S/39Qzt4CswvMRyr+OcPGePXBQfx2dxr92XhWmfJmLtKIQ2xv9gg49JWoEqR
5Ytwbbc4YCR8xjWdWRpBAv+TcJYj9dgSRp35WaRrpe341rsPdCFGcHLzpikh
EXXbzs6Ii6UGzPe47PlmFqVt2R/Z/xrg+k2+3wuRxNPoRFHtFapW5TVU/6YE
2miuk/pLuRiEIvf0BJsQpyHjIDy6rDqFuVcWN5pueIBshJ4sJDwlGDaHs/z+
+N2WBGmybv5esAyqvQtTgu4+UBw8wFYHsbnSSzO7T3VG5Ve5m1K8TiBvLLA8
nGDfzy5eaQfOJy2F9jFCNoTUOKGRp+epdPSkwzT35Ik4MpkpG9oeP32zVAlT
y6qouOFcya1JwiVLWcjebkoovcy3DdIHdrv9xX0hLrjQBwQsVVoDivEONgKA
ItfXxU2fc20EoDwHRM+9w/ij1vEOD0lguz4Jsbow8k/+X4udbrvZIQ2k8Lt7
0nVIzBCmDt8Lw1GSvEirvPWsamoyJfGycMMIBWb/q3TupZFB+aS7KAbD27Jf
p9zrfFR/oQ4F7nLTeffnbecfG45l+oKetLtR2V6FwzKh1MwJQ2/mBu4W6NpJ
lUayrORfxWNghwZR8wbX4Vq42wHxPElxYZAoyKIoEDL3E+7YeW7753xBRANS
2DBZ+3x1KC1WO1BLq/5z1plF/SciFaXB0aHVBHanQGnaTw4iIN3CTSmX2hac
KECUYoDJFjvQ33qvJ/8yTJveqpcdFaopjbxxFhiFBGYGjZsuLo8ewrrORqvo
qSnP2Hend46xxINCYYqZ5yLQG1zjd7oJld3HVUnR4GC06FuTNGs2C+bKjgvN
+6Is1iZaaYxVJaxdNr9eYmiGeRliEeGAPey2kHsZKw9a3jWcXGMIEWwYfF8k
OFIqTCZBk4Jlfm3utJk9myTCKIOC0nQWoIDxjSMdCH4fTbBWdxrJi4jyVPCl
7ULOsOx4KAJ5fFoXVneRyUj148+GV3lt3CJHjkzLn52xIkfY286dNVVGaCZe
dNKQtH9UP6Ko9DoLZzIxnoJqkaPcmDbtDp96DVS/M6DJV1nFKEAWP/Kv75om
5LW5IhKr+/VO5YWOyIpkW7t17vFkjWtaPKstq0Oo3mmTApiPrQJ1FC8bgjyj
dF38O4yJ6ltUbdRmx/VxX5ocB30YDfjmzaBrRr+GEAnq/oGA2lczmjvDi+39
smVEyCi6WEWOhQxhgGbCBUR4XJT+eUAcRW9Q16EIHwPZ4qBS1Bu6DBXgQxnI
ARlChGPxBlg96OStOZyPq8odaJ6JiHhfyxOtqMUvFTZu0M2sZSufVs0slGWu
PaclpDwvw/D8fF7xSd7IKbWxAyQBmoh7rep+l6/abyFigqXthUT0GRCmBciS
ChKUGzAj9KDxC3/3sEe/bN7YxnSn9jnBXT/+uWFjp/3d4eLVG7gmYGMIWpTF
y4KsVKKpK/xu9z2B/icVK8rZF8ruHSGfRdg1zc01HgWstvzNkh7eevY1qQrO
ZJbUH9gHUKWY0SFQOvL4GPSUFta+Toa0NPfkiTgymSkb2h4/fbNUCXB5wzQ5
JmZV1qSDmAj2CI9B260pajHxTkawo1pcu6PaBkHEs/mqQ29qXHl/aNg6g5p0
XnOphEO/3WazGgdDzV24u4pCpgMBaIVU3MObIpmabP/BnAk2st3dkJDyzqMW
a6FXq6Qjh23eKTg00Kk6nyznfqX4G/As7v1hGt6Cvf63dNKQtH9UP6Ko9DoL
ZzIxnoJqkaPcmDbtDp96DVS/M6A97Kuz4vIG0lx/SVLlEIrdu0eUPgnWv6IT
gtAEDfMjm7mtiPNacmoGqjjxYiF+GsrOTiCh95Ls59Yvd9Kc08BBQ26KM19T
ivv+461alGWfeRiCNgaocNMNV6iccZzPRUgUZizQJjXanMdI2YKu9ygXxmbJ
T/8NKOnjvEpiNz53/qM1iSuM6TERvALSnTo/f6rScwcbBkH+Ym02q7X5GgPA
Jd7lCHh3ZfiSl+wS4vjhMRJu3dJsYJkk0Hr3+LkY/jJQ4VPiLKhcDwyxDw+L
eLf2jfThSn+aMP9Rms0X3wgD9/FCyUBoJE7Eatk6K6AIsxMJTCWxvxU1LhFH
mvxpMi80+hxe0MsNjM7Aji/ZGCl/v2dKoqSvBRtRvZT2cCIOKkuWdRb4Zf8d
LGnFKAspMDjfKSDfpRaBv9SdnFl5eGpm0XJlRmjbxZ2HhF/HsDGHCvq5V8/Z
BMqgw1ECshyeR/j6SRXHaul0uOuriW/GjEl6UjHu9BGHJdxoeZFN2CYgM5ZH
2yim/Q2vQQsd1i2hkVyZVOqvJDpw78vhtUJHmp7aEvG9nFMz303wOQa+MDFN
+ZvZqVgCD0L/mkpmvM/Css/VP7+MNo7X2LBV5En1XZH+J6GT7g1SAilidryV
h6TVfjNuWx/TSDUohlm22Se8YDO4sCVECFUKzVfzycVsfCQom0Ay1u6gm2lz
xEYEAXa1AY46R7EG8XYzNGwKoTCHwOhXeiNU9drxIjwh430xwlxwH2z2Es7M
MlD2ZA1UnJP+/kWycZ3CV0GrD3Xd1on1GWhPjHOGqYAYCaEh6vuU6vzTTS9d
zSGFgfoXZnL5TDwwYSLBv0uZhpyXmz1lh9JpgaMaw80ddqMRAGm23rx9mQUm
yeFyHi9n5XmOA/ZMcAxch/cgS2U35/YSSwXpEpDc8oeuuGKLuvQTaHjFJw+F
YwyqHpGeHLl///X72onusPD/YfdA+6siV5idEnnE1VxaEmpJL4rV8eorJEbG
ckqS5rzUr6EmWnZESQGirveL2Q9RYKpTPII9YubF3NTrFDrFcytUoz5wvoNu
Xsy+paYc3blX4aToa2dsXDclPyl/FltFaFifwJSxKfYQ4wLwXiRkL0O50QJ2
/DZ0QePW5xpkBVdez24mllUgMkiZ39og1w7463Jt6QgsWGT3xeWejv2Cxvvm
jhNhQdXRjQOnq1wJKPfq3RPiJeuyNRrlHoMm8PgTJPgpf1QmJZfztc4vzN37
ruxl4cvWfRLQkgWtnTtIN50ohHYscHH7qsfEJP2w87D2StkCEUlFT9dqhnnP
2vyl4tEqVZzHqoLDOxb1KB/yvGZ7LycHRXALju9dWq9i5cc0JQ6ZWq6fZOJn
oXdixw8wtP4FfTXCmqTEVI+RKp/mmygao/NNd95YVNdchvaFALl/oHzuzqyI
24oR2WNfvFJpJkTomBxjD4o8lQq8RMg+bVbDBTpYStwr5bk9vEmq0ftg19Nj
NIsiKIqniKqVacSZmpTLqisF6Qm9RuYWDDQ/+A8bEH5329Xa9Mt49wSiWK5r
Cth3aDUrz+hDMEvbnnq9eXz8kniE6YR1UtSP2Qh0IvTnup7H8gQW8yrVUNB/
DAbpvAshHjJNT5rGma57RarMyGfcE5wzoB/D2mEmOnvBQ3cWSoXMp0KuFUYQ
e+8d8m/Rm/oJ7PHUI4x1FOYc8vrkBKQRGHE4MsDWoKqi0uNWomtAWKJv2cRL
ZcfA9bTpNssCL4zEJhvE9qLBdE6LsP1SRf4ZL7oOak3ol/gw8BBnTNYBPd3T
j9ZtI3fo65XE3POw9tA84OK4MPQ2w8IeoiZpKRs6pG2MwltomB9+cQgNPU6W
mmOgPH4AIpajonCTMVLXEoH6ywuivVFseD37jkcfo9LwKTeyLql193OcMwc2
V30T0M0GJ8vdM5QathnQ9h5OTn1vp62l2+XLxFASVYdRHMcC5dQ/0UpPIV8I
bC0mmJGUW72z8RDE0JiRLADveWLtaO8Nf7MrSDmvYG23hYOlmC3LzGhzf9/K
EHBRcLWoTO8HUkTcorGQldwhrAOqhQJxpEnocyi1bPXo7lvnkTPxCdfnpw+o
k8Y9lNUVsCQ9c/7R40fnXDdvqmZpUxix6Uet9Dx4E9QSoEakLqfSbq8CKGvN
VIjxOKT7FffsV8M+l6hnKx3Ifu48XfaTPt6CLj3HaDYRM/DoN+iT2yz8UCsP
oYnlmIcEDwn93JwViU0EeKUIKgIhR/90g/VAbHQqajIWgJDw9nsIWEt11gSc
vkuNYxRBgfYubHSXfj6IrKz/FesZCq4RGasq4DXsw3u6OwU0VDoqJjKbPt+Z
i1nWRcTKOa3+wI4eWUozxi4VlPcPA+YZlqyBjXJyocuDnPivOrwAvhE8Kb0T
QKMQNlD2cb1reAuccquLtAeKynd/lC2eFwQA+WwI0O6CmMiSvvzOrJafYT6g
Ik3O9TsYqekLjOzxtja1gTsv/WqhnkRCUPdettD2+aM+cL6Dbl7MvqWmHN25
V+G9OtSjH8qIMM1wyHwieGbSPwc6bxVjXzA0utJSVBcg0czEZcC7TrdRWKFo
V/rsAYbmBrCZQhhTMWTJJUoWiWTAGs/TdidutfjfatTifEpDICMJsXVw95lr
iP1ThvTeyfTEJ4UX6tYgMmm1BtGQnDYYP5/r0Ac2RvNLXBfBZP8vWqEmWnZE
SQGirveL2Q9RYKqy6z0ZA9MHfBsBN1vbh6brocfnqE/K8YZ9XWHySi3EbpO3
WAXLRz8R0TEa8/+1FaiCS6s46Id5FlIlJNPCRnyEwFH+vOctUiFRWSHRfFyp
0JjQImexYy11DMA1XoID0Cchd/gbeNwJ0NWaOxr79pzRfFWbL9OtYbYq7Hob
3iJ12BP8TSEjHpph5YrxBkIXCz1yCbfgAuz7M9OIFuKbuOB2E93Ag2UazCU/
M/HosMgHbZ6kM1u6ZFsJ52Syng0wJ37eVAKeTf6xpGyyt7PkaLByGwoumfHS
Qd6MzWhLOjr5rcWRx8Zh+wy7PyfrSO/bOhZf0Jtd0XDi9/2viK0R5kqWDrBO
FspIuW16TuTzbepE22QCCUIxR4Do2Pvc1NFNWzdt2yTHmp7tTj2tg+boBMzv
EBahMLE82/ewIFqrylvVVeGN2PmUk2PhTT0q04SiDDkURKI6NYjsfmRRCEul
8pcCiyYxN8OLAVsS1Nja3cLtr23bJMeanu1OPa2D5ugEzO8lrYy74GAiWJE6
aJ3Klynl6xdGzNO3DxPzlAKbDP1Qa3ctef1Ft1v9SH+IizM8x4V4mb7bA+VM
ljW83EylJBIfOkZQpsiKSxBS0iVljJZgqpGeHLl///X72onusPD/YffM+0VW
oqHgjTacyxYEgTFISL7YozZWM4qm6rmqr+t2pj+2ZOjNNdRRLWeIlxaWcy4x
ohN68uJrjqvezl2mesqzbcLIscstpRghSj90pns3pjaFfMrN1O4ROYTdpz0F
Nx0KfYhy59wIc9thpYO5+1RYhSaUvI0w7smWPFNkRjB151viHPPNpyrTvMze
T+ertJLe9Ue7D53lECtI9ZB+5/4qQLQXBWk3uO0GRzSoBQSmVu/ZEMaL/e42
YqjhMxaDKH0ZjkycivTDUM5iKmI5MNPVRdZRWzoQlfUrU4O0WcKVbij18B+m
A996veUi7Qwm/R1SRWhT7AZj5fQaeqCOFq3KHvVS7gAqvK3E6sFjjh4WlDQ1
PeyYIDyHRScn7CUOEINHzgmUfJ+wz/R757SHaTZiY1VSP9aZUntR2aMERCoa
MBwDwG3gNxERxlpKjTxSOfdD1MSIXEYTfuw1RWkHGhhbGJLop7zuhYYFKTl0
BWIPNkaRkl/NPp2L6DIdh1fBhSiOXt63II/kj9eQ/y1vleF56REkrPQkAiJb
dPp9dAYEIpwtoHFnlqI87MFqx2UGDzqP/8yeKzVRs+j9CsdhGV9uxDX5Xn0r
OGjitKn8z+NPbaoybWz4n8LdwiCs6AlKfAhlkTopqg4Eq1+Gvuh9QLkDKbWw
tf5V+pzpoAyX2R60P1gbSO3fJU1zEMf7h9BqVLhxpJ3nE2TPq4022I2kT0m4
J4aGXLaqY7Snnyqtzg6tafmuJSwPAmeTcj/N9q9JnR8ijX3bUzHTHKZmZCWA
qI0yqtPiQunj4POCA+mCocdZhxhasOGK6D4jKscbyE/JB7bvBHs+eKzYvuF3
kTaUintprg8IX/9QT64Jtg2fUPt5DCr20Lc5jR4CMm4GIkoYQpdeeiJNGC3L
pdvyo1XdSknqZaAk5iOooKhW8+/Tnj7Vf2uvL1UkaYxD00snV/9k2bAUN5+a
H82BxaVoe7NvP69wef7bWg+itMA3LtIJkKjBqkrQcAob4RVD1OOZDOEqgUSg
/AXqO+GSiO7/xB3aFIndS4Ebl8CxyIWZb6SE/C6cgHYFjnjJK5e41beToO1b
8nz25ZWYh3GWabQZgFlG3OZjAaPTnSRHQftsmMn+7Xa5j+iQqA3vPtjEzJau
H67eImmVMVS9OWp2Wc1cwxGRok+2fJTuAinceVGLvEm8AfHKXeDimuY60K74
PXCBhHHi3ehchSUCn8Y3pgD0vIh66LWKPJ+bsunL1lV11nQAnWRg/yVQtlSN
BcqK4u1lj+WYBwchhAr8BT1xqLeS80p8BFdePLLW0THZJIr+LIuPyRvAWEaR
kl/NPp2L6DIdh1fBhSiOXt63II/kj9eQ/y1vleF56REkrPQkAiJbdPp9dAYE
IgOjQ61qnq1nlfI1sXVdVuEpdXP9w9jllrF3GTzCn2ncETPw6Dfok9ss/FAr
D6GJ5e5w24aQb0Xv0yo5C4ecELj9o9Dp3/kZ8zMBV9/j9YoDt7oxS+tFvkEH
WISIgo32BzRlMskAuA74niJFbtJiVKgRM/DoN+iT2yz8UCsPoYnl0VtdNjKv
tbdWx3i5+yHbMDITeSIS/UOVeFu8enMazEWXlXUpjM4JcZl387mj93/YOwFc
OtqxP6PsUNV9WFGaVD/8dEwuJNwZNA9jpbKL2NjQgbTD2B8VAGrRpL/W4INX
2QCa8Ts3kPmRZ9sMtjQyHZcKbiaYXI2SSYLS6RpRFm2I7NZO+lOrNb/pmhh2
J6vB2PbiTFCpBa1PYp0KUZ+GrWsMv7R3VT6AXA2KzIOsUXfXwQiDcabLgsDJ
TqqUn/1cBR5ez3OE2yO0nOa1mqKjIaYccuI4rpxe7WWg9LlmTj9p+lXxF8PE
qxYx7LqWah7FsvlSYTmQwZtHGuYqumO/Sv0DoEGH+GesU1Lr9nza5AusLrT5
0wQF76atFuApv2tsJuFqmAdTuvC5WsSIao4V869K9tBd6i3AhiatOVjdaP1T
xk72O4wlw1YVACnFE9ZwUgKemUI4rFtLhXER9lx2Jlp72EWS3yO6o72SxIcY
41qrCemqBdUplyTPAlDeUxrcptmrXYe+UopCzxHVG+shp+4EHMBGutt+NdH3
ZAaiUK0MIlG2R7BSXWVEvsBJ+5sIkzvP0LderVmIS9yHHUuEm7mtT8gH+U95
NQ08q4639JUBuE2/J6k7Mr+e4v6jVHfgqNH2UMZlqowwSNNyr/PsLKQQT+mI
7dV5dseqj3RHCKtRt55Nv/3yG3blXMGkI7z8ZAIJQjFHgOjY+9zU0U1bN23b
JMeanu1OPa2D5ugEzO8QFqEwsTzb97AgWqvKW9VV4Y3Y+ZSTY+FNPSrThKIM
ORREojo1iOx+ZFEIS6XylwKLJjE3w4sBWxLU2Nrdwu2vbdskx5qe7U49rYPm
6ATM7yWtjLvgYCJYkTponcqXKeXrF0bM07cPE/OUApsM/VBr3Qkj3Zomi2h4
mh+RaDERTA==
END;

